UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XDlWc7iOOtZ5lFJk6+lyg8xtPyqCGZBeKCfnpy9kkvo='
WHERE
key_id = 'fe34d7522e2c96242dcf31dfd15ad475bc9f0d16fd0d6f2b6c5e593e192dfbef'
AND (
token = 'XDlWc7iOOtZ5lFJk6+lyg8xtPyqCGZBeKCfnpy9kkvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)