UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BQbm/70bnAcrlZPJzoRFBLbxK0oAvPJkHIbfPQk7zf8='
WHERE
key_id = 'c6f99fc1b021f4c11785cb42103d31e9de6c132881630ed01da2fbea53bf6df6'
AND (
token = 'BQbm/70bnAcrlZPJzoRFBLbxK0oAvPJkHIbfPQk7zf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)