UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2jN2T9V8sr9h5OUwQnDvIzn6P0OLeFnIe1lCBFjJQ2E='
WHERE
key_id = 'f6747febe63a423b14e366b8b9f278f400d81b65897dffa0f949796cd4c802d0'
AND (
token = '2jN2T9V8sr9h5OUwQnDvIzn6P0OLeFnIe1lCBFjJQ2E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)