UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zEH2P5/K1Zv7qZ24NSNoyA66Nb3eNbdzrweGDfGMylg='
WHERE
key_id = '2172b7a0d0514c257adc05ce71d75619e5a805c8aa552dcafa6262b2c0f5ce36'
AND (
token = 'zEH2P5/K1Zv7qZ24NSNoyA66Nb3eNbdzrweGDfGMylg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)