UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D977Q7p7PxrNBq3RY5B0IgoRo1UOZ6uJnIpOGSSFaBA='
WHERE
key_id = 'b5cd3869ae7fe10bd3878926b165aff6ee8bdf699abc3ad4097ba1afd9734ec2'
AND (
token = 'D977Q7p7PxrNBq3RY5B0IgoRo1UOZ6uJnIpOGSSFaBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)