UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DKcYHvOAzDYcsoGtk65coxJ+EHM7jJS/UGsi2MtKDYk='
WHERE
key_id = '6f38c2a433385e9c76d7e4381372cb4ebe3a84b9a3d4ee3a1b9e3e9d0de7a3d3'
AND (
token = 'DKcYHvOAzDYcsoGtk65coxJ+EHM7jJS/UGsi2MtKDYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)