UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BX6M4oUur/X/rJAZEgOcBOvCDmycS7uqrVPuOdEtoAE='
WHERE
key_id = '03f3b585ae95605dae57010fc35912994f332b9d25332f265a4d652afe618f68'
AND (
token = 'BX6M4oUur/X/rJAZEgOcBOvCDmycS7uqrVPuOdEtoAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)