UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oHvZ6IJn1dWKaqBRj2vy9PzgQSf8OUkMgzW+cA3Dwfg=' 
WHERE 
  key_id = '1f68cb1232099e2f5beec89c05d2c80324f7cb76d4177299b956d31238be903f' 
  AND (
    token = 'oHvZ6IJn1dWKaqBRj2vy9PzgQSf8OUkMgzW+cA3Dwfg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020