UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vSfiB3JakI/VZ/RtzRSIxlwImrHzqij6/tLM1jnnrYU='
WHERE
key_id = '47fdeff19c91ee54d2f96498e4fe2a86df0764b580a2f9eaa0d7cd43bd511049'
AND (
token = 'vSfiB3JakI/VZ/RtzRSIxlwImrHzqij6/tLM1jnnrYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)