UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '705YiWnMIs+F13+Z31CeWPyrT7wCtAa6mKhOH9z9hLw='
WHERE
key_id = 'a1be45549bc6daf67c5b3d2f31f06c562857a918f0240a70e7291e33287a004e'
AND (
token = '705YiWnMIs+F13+Z31CeWPyrT7wCtAa6mKhOH9z9hLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)