UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mo200ED84Lg1oS6+fb8Nsg21ksh7Mp8pP/eRX/4XP5s='
WHERE
key_id = '6506688f927520eb4f94716ab8cd0867b6760c0357b3b6e68dd76ce4887bc9e6'
AND (
token = 'mo200ED84Lg1oS6+fb8Nsg21ksh7Mp8pP/eRX/4XP5s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)