UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aPhtSX+jiI3CCd6dH9naHAxleYF+BDGtItCfH7TIu80='
WHERE
key_id = 'b27aea22b29039128c813265089ba16cdf7e2824d38f9694458b97d43121bfc9'
AND (
token = 'aPhtSX+jiI3CCd6dH9naHAxleYF+BDGtItCfH7TIu80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)