UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4itQv1TzEq3vpLXJnaegRkezvhUY/5dnPEDN9wsdj0Q='
WHERE
key_id = 'f9441da5c69226a49f431efa4d9fa0c50b8f276721565b7e07788c64f5c83139'
AND (
token = '4itQv1TzEq3vpLXJnaegRkezvhUY/5dnPEDN9wsdj0Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)