UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A9zL07mVNeQJ331Q8zDxYVaLNj5cSqWPP+JSw/DSuhc='
WHERE
key_id = 'c4f2c1a37eb19fc257f5e64a4dfa5005f130e33e0fd85ccfeb32c6275362ed42'
AND (
token = 'A9zL07mVNeQJ331Q8zDxYVaLNj5cSqWPP+JSw/DSuhc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)