UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KJgvSkK5248KXfzmykvLS6kNJiEJ8McvphIe6SaM8ck='
WHERE
key_id = 'f2f4d667bf4ae71d0af46f1bb779b8915330ea54e23173e55b9f76f62c5c01f8'
AND (
token = 'KJgvSkK5248KXfzmykvLS6kNJiEJ8McvphIe6SaM8ck='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)