UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lq2o3Z7OMaWfe/Wwjy5R3u36mC85wYmWqtLmSPG7B0Y='
WHERE
key_id = 'e23404e3738f9f32a0bacc86eb4bace89c768920b6d7e0ffc3015077af3bda9b'
AND (
token = 'Lq2o3Z7OMaWfe/Wwjy5R3u36mC85wYmWqtLmSPG7B0Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)