UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UY0hLoigBhnp3lK6j7Fafu0S7tA9VdazI3QUjjrtZrM='
WHERE
key_id = 'caa26390ca823c2445612229add2be6e6af8dc88f8776a25d0a8e74347e44d9f'
AND (
token = 'UY0hLoigBhnp3lK6j7Fafu0S7tA9VdazI3QUjjrtZrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)