UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'efrN7o6epN/NDvbeqZ2OnzIwnYq4ZocED0xXCbnSDXw='
WHERE
key_id = '235223d0bfade14ae11a3cafa2adf07cd106b3fd30d6ce308acaea767dd3ff0e'
AND (
token = 'efrN7o6epN/NDvbeqZ2OnzIwnYq4ZocED0xXCbnSDXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)