UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G/C1qMxSBbJqCf/gyh7iTcQ7QXj3RquqDRFRKWuNMnY='
WHERE
key_id = '8eae0f368febcc55336325c2b3a0c003204f10423498512be2375d17c84c5646'
AND (
token = 'G/C1qMxSBbJqCf/gyh7iTcQ7QXj3RquqDRFRKWuNMnY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)