UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qfnj0eLNKEE5eUOw/QbPNWnMYyGkpwcojCD6oYwmOCw='
WHERE
key_id = 'dbd95358955b7bb941b02f8f514f29c9cef992ca4a7e1201301f312aee2f8746'
AND (
token = 'Qfnj0eLNKEE5eUOw/QbPNWnMYyGkpwcojCD6oYwmOCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)