UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6KOK9B1RSXq73JaX03mdyMJFMd+wH2ptI82hwT/t9dg='
WHERE
key_id = '3fbe24581e1923d4c042effcdc18fc372458080591b2b59f5a97ad4188cb7be7'
AND (
token = '6KOK9B1RSXq73JaX03mdyMJFMd+wH2ptI82hwT/t9dg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)