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