UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W/gs5laURoy6us3Dr6VXN4flQYuOKWusbmJAxZzBGyA='
WHERE
key_id = '117c2a295e315f1697a8b11aa766617e26a9d144bbd633458d02faff9f0be9a3'
AND (
token = 'W/gs5laURoy6us3Dr6VXN4flQYuOKWusbmJAxZzBGyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)