UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8shWb03Y9wHXux4cTLpPFnM4ib0iut49qiaEveaBmgA='
WHERE
key_id = '4676b96183e5d9255e9fe507471b6ff66307b4a92d9907f61f636b6c09b9e43d'
AND (
token = '8shWb03Y9wHXux4cTLpPFnM4ib0iut49qiaEveaBmgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)