UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eQ8nMSSUvcHWlu7zvBd6YoboLnhpMYRh04cv+ogddFE='
WHERE
key_id = '300d7174b59080574ca062d16d4cf606173abab9befe01e06cdee6dbb708072a'
AND (
token = 'eQ8nMSSUvcHWlu7zvBd6YoboLnhpMYRh04cv+ogddFE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)