UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WNTAJkQCOH1XGS+2YPI72MezEjOx/PFClyxoSt+/K6Q='
WHERE
key_id = 'ab5bfd9b1e6293252bb28336376c6d882ed0d7e3dd54f443e1ed6776e231c12d'
AND (
token = 'WNTAJkQCOH1XGS+2YPI72MezEjOx/PFClyxoSt+/K6Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)