UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mtQoImGczC08Pp1G4tf2ua6FRpV7qxZMMCQnt05um3A='
WHERE
key_id = '49783b7aa0233364e25fb06c373c2f087249cce42f6651c874d60ec288ccdbf6'
AND (
token = 'mtQoImGczC08Pp1G4tf2ua6FRpV7qxZMMCQnt05um3A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)