UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x7+sx8WDzTfov98syv/iyrNazhiHOV1CQ/2t8wyaxIU='
WHERE
key_id = '3118ee0cb4048202bc4708199a3dcf82f54fbbef3337769266fef4d2adb6d03f'
AND (
token = 'x7+sx8WDzTfov98syv/iyrNazhiHOV1CQ/2t8wyaxIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)